Stored Procedures List
The following list includes the stored procedures currently available that can be used to create Reports.
| Title | Parameters | Data Fields | ||
|---|---|---|---|---|
| Audit | UserId, ObjectId, ObjectType, StartDate, EndDate | Change Date, Change Description, Department Name, DepartmentID, File Number, File Title, FileID, LogID, log Type, Object Type, Object Type ID, Organisation, OrganisationID, RequesterID, RequesterName, UserID, UserName | ||
| DepartmentFileList | UserId, FileTitle, FileNumber | Department Contact Message, Department Contact Person, Department Name, DeptID, Document Created By, Document Creation Date, Document Last Updated By, Document Last Updated Date, File Contact Person, File Created By, File Creation Date, File Deadline, File Is Active, File is Public, File Last Updated By, File Last Updated Date, File Level, File Name, File Number, File Status, File Type, FileID, FileLevelID, FileStatusID, FileTypeID | ||
| DepartmentList | UserId, DepartmentTitle | Contact Person, Creation date, Department Created By, Department Name, Department Updated By, DepartmentID, Last Updated Date, OrganisationID | ||
| DepartmentUsers | UserId, DepartmentTitle | Department Contact Person, Department Created By, Department Created Date, Department Last Updated By, Department Last Updated Date, Department Name, DepartmentID, First Name, Full Name, Last Name, OrganisationID, User Created By, User Creation Date, User Last Login, User Last Update Date, User Name, User Updated By, UserID | ||
| DocumentAssociationList | UserId, FileTitle, FileNumber, DocTitle, DocNumber | Association Def Label, AssociationDefID, AssociationID, Document Created By, Document Creation date, Document Last Updated By, Document Last Updated Date, Document Number, Document Title, DocumentID, File Created By, File Creation Date, File Label, File Last Updated By, File Last Updated Date, File Number, FileID, Forward Description, From Object Def, From Object label, From ObjectID, Is Time Dependant, Reverse Description, To Object Def, To Object Label, ToObjectID | ||
| DocumentAttachments | UserId, FileTitle, FileNumber, DocTitle, DocNumber | Attachment Blob Name, Attachment Description, Attachment File Name, Attachment Name, AttachmentID, Document Title, DocumentID, File Label, File Number, FileID | ||
| DocumentEntitiesList | UserId, FileTitle, FileNumber, DocTitle, DocNumber | Document Created By, Document Creation Date, Document Last Updated By, Document Last Updated Date, Document Number, Document Title, DocumentID, Entity Created By, Entity Creation Date, Entity Def Label, Entity Last Updated By, Entity Last Updated Date, Entity Name, EntityID, File Created By, File Creation Date, File Last Updated By, File Last Updated Date, File Name, File Number, FileID, Icon URL, ObjectDefID | ||
| Documents | UserId, FileTitle, FileNumber, DocTitle, DocNumber | Area of Responsibility, Content, Department, DepartmentID, Document Created By, Document Creation Date, Document Handling Instruction, Document Last Updated By, Document Last Updated date, Document Number, Document Owner, Document Title, Document Type, DocumentID, Document Type ID, Event date, File Created By, File Creation date, File Last Updated By, File Last Updated Date, File Name, File Number, FileID, HandlingInstructionID, Info Received Date, InfoReliabilityID, ObjectName, ObjectName_1, ObjectDefID, ObjectID, OrganisationID, OwnerID, Reliability Code, Source description, Source Name, Source Type, SourceReliabilityID | ||
| DocumentListByRegionSite | UserID, Site, Region, DocumentType, ProvidedBy, FromDate, ToDate | Area of Responsibility, Content, Department, DepartmentID, Document Created By, Document Creation Date, Document Handling Instruction, Document Last Updated By, Document Last Updated date, Document Number, Document Owner, Document Title, Document Type, DocumentID, Document Type ID, Event date, File Created By, File Creation date, File Last Updated By, File Last Updated Date, File Name, File Number, FileID, HandlingInstructionID, Info Received Date, InfoReliabilityID, ObjectName, ObjectName_1, ObjectDefID, ObjectID, OrganisationID, OwnerID, Provided By, Region, Reliability Code, Site, Source description, Source Name, Source Type, SourceReliabilityID | ||
| DocumentTagList | UserId, FileTitle, FileNumber, DocTitle, DocNumber | DocumentID, DocumentTitle, DocumentCreatedBy, DocumentCreationDate, DocumentLastUpdatedBy, DocumentLastUpdatedDate, FileID, FileName, FileCreatedBy, FileCreationDate, FileLastUpdatedBy, FileLastUpdatedDate, TagID, TagName, TagNotes, TagCreatedBy, TagCreationDate, TagLastUpdatedBy, TagLastUpdatedDate | ||
| DocumentUsers | UserId, FileTitle, FileNumber, DocTitle, DocNumber | Contact Person, Document Created By, Document Created date, Document Last Updated By, Document Last Updated Date, Document Title, DocumentID, Document Number, Document TypeID, File Created By, File Creation date, File Last Updated By, File Last Updated Date, FileID, File Number, First Name, Label, Last Name, User Created By, User Creation date, User Last Updated By, User Last Updated Date, UserID, UserName | ||
| Entity Links | UserId, AssociationType, EntityTypeFrom, EntityTypeTo, AssociationStart, AssociationFinish | AssociationID, AssociationTypeID, Association Type, Association Type Description, Association Start Date, Association Finish Date, Association Created By, Association Creation Date, Association Last Updated By, Association Last Updated Date, FromEntityID, From Entity Type, Reformat From Entity Type, Entity From Created By, Entity From Creation Date, Entity From Last Updated By, Entity From Last Updated Date, ToEntityID, To Entity Type, Reformat To Entity Type, Entity To Created By, Entity To Creation Date, Entity To Last Updated By, Entity To Last Updated Date, From Entity Def, To Entity Def, Forward Description, Reverse Description, Is Time Dependent | ||
| EntityAttachmentList | UserId, EntityLabel | Attachment Created By, Attachment Creation Date, Attachment Description, Attachment FileName, AttachmentID, Attachment Updated By, Attachment Updated Date, Entity Created By, Entity Created Date, EntityID, Entity Name, Entity Updated By, Entity Updated Date | ||
| Entities | UserId, PropertyType, Property | Label (Entity Identifier), Property, Entity ID | ||
| FileDocuments | UserId, FileNumber | Document ID, Document Title, Document Number, Event Date, FileID, File Number, Type Label | ||
| FileDocumentsbyFileID | UserId | DocumentID, FileID, DocumentNumber, TypeLabel, Description, EventDate | ||
| FileList | UserId, FileTitle, FileNumber | FileID, File Number, File Title, FileTypeID, File Type, FileStatusID, File Status, FileLevelID, File level, Contact Person, Contact Message, Deadline, is Public, File Created By, File Creation Date, File Last Updated By, File Last Updated Date | ||
| Files | UserId | Contact Message, Contact Person, Created By, Creation Date, Deadline, File Level, File Status, File Type, File ID, File Level Id, File Number, File Status ID, File Title, File Type ID, Is Active, Is Public, Last Update Date, Last Updated By, Modified By, (Selected Key Player Type Set ID - currently not in use) | ||
| FileUserList | UserId, FileTitle, FileNumber | File Contact Person, File Created By, File Creation Date, File ID, File Last Updated By, File Last Updated Date, File Name, File Number, User Created By, User Creation Date, User First Name, User Last Login, User Last name, User Name, User ID | ||
| NoteTagList | UserId, NoteType, Tags, DateRangeStart, DateRangeEnd | Document Ref, Entity ID, Note Creation Date, Note Content, Note Type, Tags | ||
| NoteTypeLookup | (can only be used as a join to another Query) | Note Type | ||
| OrganisationUsers | UserId | First name, Full Name,, Last Name, Organisation, Organisation Created By, Organisation Creation Date, Organisation Last Updated By, Organisation Last Updated Date, Org ID, User Created By, User Creation Date, User Last Login, User Last Update Date, User Name, User Updated By, User ID | ||
| PropertyLookup | (can only be used as a join to another Query) | Property Type | ||
| TagListByEntity | Userid PropertyType Tags |
UserId, EntityID, Property, PropertyType, Tags | ||
| TagLookup | (can only be used as a join to another Query) | Tags | ||
| TaskList | UserId, FileTitle, FileNumber, FileStatus | AssigneeID, CategoryID, Created By ID, Department ID, Due Date, File Created By, File Creation Date, File Last Updated By, File Last Updated Date, File Name, FileID, File Number, Last Updated By ID, Organisation ID, Owner ID, Parent Task ID, Status ID, Task Assignee, Task Category, Task Created By, Task Creation Date, Task Description, Task Last Update Date, Task Last Updated By, Task Owner, Task Status, Task Title, Task ID, Template ID | ||